Abstract: Data warehouse technology transforms the operational data store to general and compositive information
نویسندگان
چکیده
Data warehouse technology transforms the operational data store to general and compositive information. It also provides effective way for analysis and statistic to the mass data, and helps to do the decision-making. The paper introduces the data warehouse and the online analysis process. According to the power management information system, the paper analyzes the power-oriented multidimensional database modeling and the presentation of multidimensional views. The system also builds power-oriented data warehouse using DB2 database, Warehouse Manager, Cube View and Alphablox of IBM. Then, this paper discusses the concrete applications of data warehouse in completing the extract, transform and load (ETL) of power data. The discussion includes the optimization of the system after creating the MQT tables using Cube View and the presentation of the analysis system. The system can help power corporations to do the decision-making.
منابع مشابه
Application of data warehouse technology in power analysis
Data warehouse technology transforms the operational data store to general and compositive information. It also provides effective way for analysis and statistic to the mass data, and helps to do the decision-making. The paper introduces the data warehouse and the online analysis process. According to the power management information system, the paper analyzes the power-oriented multidimensiona...
متن کاملA Convenient Way From Normalized Database To Denormalized Database
Data warehouse is a denormalized and information oriented system used to convert business rules into useful information as it is the collection of archived operational data which is useful in tactical and strategic business decisions. A relational database consists of a collection of tables that store particular sets of data in a form of normalized database. We use ER Model in relational databa...
متن کاملModeling-Centered Data Warehousing Learning: Methods, Concepts and Resources
Though data warehousing is widely recognized in the industry as the principal decision support system architecture and an integral part of the corporate information system, the majority of academic institutions in the US and world-wide have been slow in developing curriculums that reflect this. The authors examine the issues that have contributed to the lag in the coverage of data warehousing t...
متن کاملFuzzy multi-criteria selection procedures in choosing data source
Technology assessment and selection has a substantial impact on organizations procedures in regards to technology transfer. Technological decisions are usually made by a group of experts, and whereby integrity of these viewpoints to a single decision can be quite complex. Today, operational databases and data warehouses exist to manage and organize data with specific features and henceforth, th...
متن کاملDevelopment of A Medical Informatics Data Warehouse
This project built a medical informatics data warehouse (MedInfo DDW) in an Oracle database to analyze medical information which has been collected through Baylor Family Medicine Clinic (FCM) Logician application. The MedInfo DDW used Star Schema with dimensional model, FCM database as operational data store (ODS); the data from on-line transaction processing (OLTP) were extracted and transferr...
متن کامل